<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10" viewPagesAsTabs="topLeft"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 14:40:43--><!--RSU-SPC-0093 The report specification was upgraded from &amp;amp;amp;quot;http://developer.cognos.com/schemas/report/8.0/&amp;amp;amp;quot; to &amp;amp;amp;quot;http://developer.cognos.com/schemas/report/11.0/&amp;amp;amp;quot; at 2015-8-27. 7:48:55-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Volume Daily Performance']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Top 10 Applications"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications by Performance</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:10px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Average Total IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart9" refQuery="Top 10 Apps by IOpS">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis>
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Avg IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="height:400px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;text-align:center;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="text-align:left"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Peak IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart10" refQuery="Top 10 Apps by Peak IOpS">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis>
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Peak IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="height:400px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;text-align:center;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:10px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Avg IO, MBps and Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List5" refQuery="Top 10 Apps by IOpS">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Avg IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Avg IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' MBps'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Avg Response Time (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Avg Response Time (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Avg IOpS" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:10px;text-align:left"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Peak IO, MBps and Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List6" refQuery="Top 10 Apps by Peak IOpS">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' MBps'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Response Time (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Response Time (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Peak IOpS" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:10px;text-align:left;padding-left:10px;padding-bottom:25px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:25px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						<page name="Bottom 10 Applications">
			<pageBody>
				<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Bottom 10 Applications by Performance</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:10px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Bottom 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Average Total IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart13" refQuery="Bottom 10 Apps by IOpS">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis>
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Avg IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Avg IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="height:400px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;text-align:center;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="text-align:left"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Bottom 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Peak IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart depth="9" maxHotspots="10000" name="Combination Chart14" refQuery="Bottom 10 Apps by Peak IOpS">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis>
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Peak IOpS"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar barShape="box" borderColor="white">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Peak IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="height:400px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                <noDataHandler>
                                                                                    <contents>
                                                                                        <block>
                                                                                            <contents>
                                                                                                <textItem>
                                                                                                    <dataSource>
                                                                                                        <staticValue>No Data Available</staticValue>
                                                                                                    </dataSource>
                                                                                                    <style>
                                                                                                        <CSS value="padding:10px 18px;"/>
                                                                                                    </style>
                                                                                                </textItem>
                                                                                            </contents>
                                                                                        </block>
                                                                                    </contents>
                                                                                </noDataHandler>
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;text-align:center;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:10px;vertical-align:top"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Bottom 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Avg IO, MBps and Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List9" refQuery="Bottom 10 Apps by IOpS">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Avg IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Avg IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' MBps'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Avg Response Time (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Avg Response Time (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:10px;text-align:left"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Bottom 10 Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Peak IO, MBps and Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List10" refQuery="Bottom 10 Apps by Peak IOpS">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###' MBps'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Throughput (MB/sec)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak Response Time (ms)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="color:#454545"/><dataFormat><numberFormat pattern="###.#' ms'"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak Response Time (ms)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:10px;text-align:left;padding-left:10px;padding-bottom:25px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:25px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="pb"/>
					</defaultStyles>
				</style>
			</pageBody>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="pg"/>
				</defaultStyles>
			</style>
		</page></reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.889Z"/></XMLAttributes><reportName>3.7 Top 10 and Bottom 10 Applications by Performance</reportName><queries><query name="Top 10 Apps by IOpS">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
perf.businessUnit as 'Business Unit',
perf.application as 'Application',
ROUND(SUM(perf.avgIOpS),0) as 'Avg IOpS',
ROUND(SUM(perf.peakIOpS),0) as 'Peak IOpS',
ROUND(SUM(perf.totalThroughput),0) as 'Total Throughput (MB/sec)',
ROUND(SUM(perf.peakThroughput),0) as 'Peak Throughput (MB/sec)',
ROUND(AVG(perf.avgResponseTime),2) as 'Avg Response Time (ms)',
ROUND(MAX(perf.peakResponseTime),2) as 'Peak Response Time (ms)',
perf.fulldate as 'Full Date'

FROM
(

SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
		
	
	
	FROM 	dwh_performance.volume_daily_performance_fact
	JOIN	dwh_performance.volume_dimension
	ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.volume_daily_performance_fact.storagePoolTk
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk
	

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.volume_dimension.tk

UNION

	SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.internal_volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.internal_volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
	
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN	dwh_performance.internal_volume_dimension
	ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagePoolTk

	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.internal_volume_dimension.tk

) perf

GROUP BY Application

ORDER BY perf.avgIOpS DESC LIMIT 10

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total Throughput (MB/sec)"/><mdProjectedItem name="Peak Throughput (MB/sec)"/><mdProjectedItem name="Avg Response Time (ms)"/><mdProjectedItem name="Peak Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem aggregate="total" name="Avg IOpS"><expression>[SQL1].[Avg IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Total Throughput (MB/sec)" aggregate="total"><expression>[SQL1].[Total Throughput (MB/sec)]</expression></dataItem><dataItem name="Peak Throughput (MB/sec)"><expression>[SQL1].[Peak Throughput (MB/sec)]</expression></dataItem><dataItem name="Avg Response Time (ms)" aggregate="maximum"><expression>[SQL1].[Avg Response Time (ms)]</expression></dataItem><dataItem name="Peak Response Time (ms)"><expression>[SQL1].[Peak Response Time (ms)]</expression></dataItem></selection>
		</query><query name="Top 10 Apps by Peak IOpS">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
perf.businessUnit as 'Business Unit',
perf.application as 'Application',
ROUND(SUM(perf.avgIOpS),0) as 'Avg IOpS',
ROUND(SUM(perf.peakIOpS),0) as 'Peak IOpS',
ROUND(SUM(perf.totalThroughput),0) as 'Total Throughput (MB/sec)',
ROUND(SUM(perf.peakThroughput),0) as 'Peak Throughput (MB/sec)',
ROUND(AVG(perf.avgResponseTime),2) as 'Avg Response Time (ms)',
ROUND(MAX(perf.peakResponseTime),2) as 'Peak Response Time (ms)',
perf.fulldate as 'Full Date'

FROM
(

SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
		
	
	
	FROM 	dwh_performance.volume_daily_performance_fact
	JOIN	dwh_performance.volume_dimension
	ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.volume_daily_performance_fact.storagePoolTk
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk
	

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.volume_dimension.tk

UNION

	SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.internal_volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.internal_volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
	
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN	dwh_performance.internal_volume_dimension
	ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagePoolTk

	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.internal_volume_dimension.tk

) perf

GROUP BY Application

ORDER BY perf.peakIOpS DESC LIMIT 10

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total Throughput (MB/sec)"/><mdProjectedItem name="Peak Throughput (MB/sec)"/><mdProjectedItem name="Avg Response Time (ms)"/><mdProjectedItem name="Peak Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem aggregate="total" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Total Throughput (MB/sec)"><expression>[SQL1].[Total Throughput (MB/sec)]</expression></dataItem><dataItem name="Peak Throughput (MB/sec)" aggregate="total"><expression>[SQL1].[Peak Throughput (MB/sec)]</expression></dataItem><dataItem name="Avg Response Time (ms)"><expression>[SQL1].[Avg Response Time (ms)]</expression></dataItem><dataItem name="Peak Response Time (ms)" aggregate="maximum"><expression>[SQL1].[Peak Response Time (ms)]</expression></dataItem></selection>
		</query><query name="Bottom 10 Apps by IOpS">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
perf.businessUnit as 'Business Unit',
perf.application as 'Application',
ROUND(SUM(perf.avgIOpS),0) as 'Avg IOpS',
ROUND(SUM(perf.peakIOpS),0) as 'Peak IOpS',
ROUND(SUM(perf.totalThroughput),0) as 'Total Throughput (MB/sec)',
ROUND(SUM(perf.peakThroughput),0) as 'Peak Throughput (MB/sec)',
ROUND(AVG(perf.avgResponseTime),2) as 'Avg Response Time (ms)',
ROUND(MAX(perf.peakResponseTime),2) as 'Peak Response Time (ms)',
perf.fulldate as 'Full Date'

FROM
(

SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
		
	
	
	FROM 	dwh_performance.volume_daily_performance_fact
	JOIN	dwh_performance.volume_dimension
	ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.volume_daily_performance_fact.storagePoolTk
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk
	

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.volume_dimension.tk

UNION

	SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.internal_volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.internal_volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
	
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN	dwh_performance.internal_volume_dimension
	ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagePoolTk

	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.internal_volume_dimension.tk

) perf

GROUP BY Application

ORDER BY perf.avgIOpS ASC LIMIT 10

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total Throughput (MB/sec)"/><mdProjectedItem name="Peak Throughput (MB/sec)"/><mdProjectedItem name="Avg Response Time (ms)"/><mdProjectedItem name="Peak Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem aggregate="total" name="Avg IOpS"><expression>[SQL1].[Avg IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Total Throughput (MB/sec)"><expression>[SQL1].[Total Throughput (MB/sec)]</expression></dataItem><dataItem name="Peak Throughput (MB/sec)"><expression>[SQL1].[Peak Throughput (MB/sec)]</expression></dataItem><dataItem name="Avg Response Time (ms)"><expression>[SQL1].[Avg Response Time (ms)]</expression></dataItem><dataItem name="Peak Response Time (ms)"><expression>[SQL1].[Peak Response Time (ms)]</expression></dataItem></selection>
		</query><query name="Bottom 10 Apps by Peak IOpS">
			<source>
				
			<sqlQuery dataSource="dwh_performance" name="SQL1">
			<sqlText>SELECT
perf.businessUnit as 'Business Unit',
perf.application as 'Application',
ROUND(SUM(perf.avgIOpS),0) as 'Avg IOpS',
ROUND(SUM(perf.peakIOpS),0) as 'Peak IOpS',
ROUND(SUM(perf.totalThroughput),0) as 'Total Throughput (MB/sec)',
ROUND(SUM(perf.peakThroughput),0) as 'Peak Throughput (MB/sec)',
ROUND(AVG(perf.avgResponseTime),2) as 'Avg Response Time (ms)',
ROUND(MAX(perf.peakResponseTime),2) as 'Peak Response Time (ms)',
perf.fulldate as 'Full Date'

FROM
(

SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
		
	
	
	FROM 	dwh_performance.volume_daily_performance_fact
	JOIN	dwh_performance.volume_dimension
	ON	dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.volume_daily_performance_fact.storagePoolTk
	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk
	

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.volume_dimension.tk

UNION

	SELECT 
	dwh_performance.business_entity_dimension.businessunit AS businessUnit,
	dwh_performance.application_dimension.name as application,
	dwh_performance.internal_volume_daily_performance_fact.totaliops AS avgIOpS,
	dwh_performance.internal_volume_daily_performance_fact.totaliopsmax AS peakIOps,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughput AS totalThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalthroughputmax AS peakThroughput,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS avgResponseTime,
	dwh_performance.internal_volume_daily_performance_fact.totalresponsetime AS peakResponseTime,
	dwh_performance.date_dimension.fulldate as fulldate,
	dwh_performance.date_dimension.repMonthOrLatest as RepMonthOrLatest
	
	FROM 	dwh_performance.internal_volume_daily_performance_fact
	JOIN	dwh_performance.internal_volume_dimension
	ON	dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
	JOIN	dwh_performance.business_entity_dimension
	ON		dwh_performance.business_entity_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.businessentitytk
	JOIN	dwh_performance.application_dimension
	ON		dwh_performance.application_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.applicationtk
	JOIN	dwh_performance.storage_dimension
	ON		dwh_performance.storage_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storageTk
	JOIN	dwh_performance.storage_pool_dimension
	ON		dwh_performance.storage_pool_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.storagePoolTk

	JOIN	dwh_performance.date_dimension
	ON		dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 8 DAY

GROUP BY dwh_performance.internal_volume_dimension.tk

) perf

GROUP BY Application

ORDER BY perf.peakIOpS ASC LIMIT 10

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Avg IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="Total Throughput (MB/sec)"/><mdProjectedItem name="Peak Throughput (MB/sec)"/><mdProjectedItem name="Avg Response Time (ms)"/><mdProjectedItem name="Peak Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem aggregate="total" name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="Total Throughput (MB/sec)"><expression>[SQL1].[Total Throughput (MB/sec)]</expression></dataItem><dataItem name="Peak Throughput (MB/sec)"><expression>[SQL1].[Peak Throughput (MB/sec)]</expression></dataItem><dataItem name="Avg Response Time (ms)"><expression>[SQL1].[Avg Response Time (ms)]</expression></dataItem><dataItem name="Peak Response Time (ms)"><expression>[SQL1].[Peak Response Time (ms)]</expression></dataItem></selection>
		</query></queries><classStyles><classStyle label="freezeColumns" name="freezeColumns"/><classStyle label="freezeRows" name="freezeRows"/><classStyle label="freezeCorner" name="freezeCorner"/></classStyles></report>